2013-09-06 - 7358.400 - Spec - Report on ROAL Data #CrystalReportDevelopment

SPECIFICATIONS

7358.400 - Report on ROAL Data


Requirement Summary

Need to write the report on ROAL material with its images and details.

Admin Info

Purpose
 Need to write the report on ROAL material with its images and details.
Requested By
 Mark Harris
Spec Created By
 Mallareddy D
Spec Created Date
 09/06/2013
Spec QA by
 Uday Kumar P
Objects
 OSA190
Document Status
 Complete

References

Prior Tickets

None

Documents

ROAL report for Sales docx.docx

Functional Requirement

1. Report needs to show only ROAL Materials.
2. Report needs to have grouping parameter which has following groupings
3. Material has to show Material ID and Material Description.
4. Need to show Quantity and Revenue in each group.
5. Once the user clicks on material ID, material image has to show which we be picked from ROAL DB.
6. Report has to show the revenue by descending order.

Solution Summary

Need to create a BEx query with the required fields and needs to include SQL code to get the material image from ROAL DB. Once the sources are ready, report needs to be developed as per the requirement.

Test Plan

SNo.
 Test Scenario
 Expected Results
1.
 Need to check the report values with BEx query
 Values shoud be identical

Solution Details

1. Need to Create BEx query.
2. Need to write SQL code to pick the material image from ROAL DB.
3. Need to include BEx query and SQL code in report and these two connections has to be linked based on material ID.
4. Need to develop the report as per the requirement.

Issues

None